--SQL UPDATE Examples 1-6

--Example 1. Change S1020's major to music.
UPDATE	Student
SET   	major = 'Music'
WHERE	stuId  =  'S1020';


--Example 2. Change Tanaka's dept to MIS and rank to Assistant.
UPDATE	Faculty
SET	department = 'MIS',rank = 'Assistant'
WHERE	name = 'Tanaka';


--Example 3. Change S1013's major back to no value.
UPDATE	Student
SET	major = NULL
WHERE	StuId = 'S1013';


--Example 4. Change grades of all students in CSC201A to A.
UPDATE	Enroll
SET	grade = 'A'
WHERE	classNumber = 'CSC201A';


--Example 5. Increment all students' credits by 3.
UPDATE	Student
SET	credits = credits + 3;


--Example 6. Change Tanaka's room to B220 for all classes.
UPDATE	Class
SET	room = 'B220'
WHERE	facId =	(SELECT	facId
		 FROM	Faculty
		 WHERE	name = 'Tanaka');